package com.hig.ledger.mapper;

import java.util.List;
import com.hig.ledger.domain.LedgerElectricianCertificate;
import org.apache.ibatis.annotations.Select;

/**
 * 电工证统计Mapper接口
 * 
 * @author scp
 * @date 2024-09-22
 */
public interface LedgerElectricianCertificateMapper 
{
    /**
     * 查询电工证统计
     * 
     * @param id 电工证统计ID
     * @return 电工证统计
     */
    public LedgerElectricianCertificate selectLedgerElectricianCertificateById(Long id);

    /**
     * 查询电工证统计列表
     * 
     * @param ledgerElectricianCertificate 电工证统计
     * @return 电工证统计集合
     */
    public List<LedgerElectricianCertificate> selectLedgerElectricianCertificateList(LedgerElectricianCertificate ledgerElectricianCertificate);

    /**
     * 新增电工证统计
     * 
     * @param ledgerElectricianCertificate 电工证统计
     * @return 结果
     */
    public int insertLedgerElectricianCertificate(LedgerElectricianCertificate ledgerElectricianCertificate);
    @Select("SELECT IFNULL(MAX(id), 0) + 1 FROM ledger_electrician_certificate")
    long getNextId();
    /**
     * 修改电工证统计
     * 
     * @param ledgerElectricianCertificate 电工证统计
     * @return 结果
     */
    public int updateLedgerElectricianCertificate(LedgerElectricianCertificate ledgerElectricianCertificate);

    /**
     * 删除电工证统计
     * 
     * @param id 电工证统计ID
     * @return 结果
     */
    public int deleteLedgerElectricianCertificateById(Long id);

    /**
     * 批量删除电工证统计
     * 
     * @param ids 需要删除的数据ID
     * @return 结果
     */
    public int deleteLedgerElectricianCertificateByIds(Long[] ids);
}
